Order Entry

Purchase Orders define the items or services to be provided by a single Vendor, along with the appropriate Payment Terms, delivery dates, item descriptions, quantities, Ship Via Methods, and all other obligations and conditions. Deacom Purchase Orders contain a header section and a lines section. The header section stores the vendor details, Facility information, payments terms, and dates. The lines section contains details regarding the items to be purchased including Part Numbers, descriptions, quantities, purchasing units, pricing, and charge to account information. Upon initial Vendor selection on a new Purchase Order, the Order Defaults defined on the Vendor's master record will populate the appropriate fields, but may be modified as needed. In addition, different purchasing scenarios are handled by the use of order types that are specified during order entry.

Any changes made to parts, payment terms, shipping terms, etc. master records will not affect existing Purchase Orders and will not take effect unless the user opens the Purchase Order and re-selects the new field value(s) in the appropriate locations on the form.

Purchase Orders can be created in multiple ways, including via

  • Purchasing > Order Entry and manually entering the information
  • Purchasing > Order Entry and importing an excel file to speed up the process
  • Inventory > MRP by using the "Create PO" and "Auto PO" options

In addition, orders can be created as Recurring, Blanket, Drop Ship, Expense, and many other types to cover all Purchasing processes for a company.

Purchase Order Entry form

Button

Description

Add

Opens the Edit Purchase Order Line form, which is used to add a new line to the Purchase Order.

Modify

Opens the Edit Purchase Order Line form, which is used to make changes to the selected line.

Delete

Deletes the selected line.

Sort

Allows the user to reorder the Purchase Order lines.

Mass Delete

Allows the user to select and delete multiple existing Purchase Order lines.

Reset

Resets the form to the default settings.

Recalc Prices

Recalculates pricing when the Pricing tab "Discount" field is entered after the Purchase Order lines. Users can set a default value to recalc PO prices on receipt.

Scan Parts

Opens the Scan Parts form, which is used to, either manually or via a Barcode scanner, enter a Part Number and quantity to be added as lines to the order.

Pay Schedule

Opens the Edit Payment Schedule form, which allows users with proper security to modify the number of payments, first payment date, payment amounts, and deposit amount.

  • Only active if the Terms selected on the order are flagged as "Multi-Payment Terms".

Vendor History

Generates a Purchasing "Purchase Order Summary" report, listing all Purchase Orders for the Vendor selected on the Purchase Order.

Copy PO

Allows the user to copy one or more lines from an existing Purchase Order, made for the same Vendor, as a base for the one being created.

If this field is selected, the system will link the newly created Purchase Order to the one being copied and insert the number of the original PO (the one being copied) into the “Link To PO” field on the Misc1 tab of the new Purchase Order.

If users prefer, this field may be set to default by following the steps below:

  • Ensure the “Link To PO” box is checked.
  • Click the “Settings” button on the Copy PO form.
  • Click the “Add” button on the Settings form to display the Edit Saved Pre-Filter form.
  • Enter a description.
  • Select the appropriate value in the “Save For” field and check the “Active” and “Default” checkboxes.
  • Save and Exit the Edit Saved Pre-Filter form.
  • Click the “Continue” button on the Settings form to complete the process.

Using the “Link To PO” field can be useful in many situations including scenarios where customers will be creating debit memos and want to link to the original PO so that debit memos can be matched with PO's on check runs and when creating manual checks.

Link POs

Opens the Link PO's form used to link multiple purchase orders to the selected single purchase order.

  • The Link PO's form (detailed in the section below) is used to generate a purchase order summary report listing the purchase orders that will be linked.
  • Useful is multiple scenarios, including situations where for example, one adjustment PO needs to be linked to multiple receipt POs.
  • The "Link PO's To" field in Purchasing > Options determines how this button and feature will link POs.
  • Added in version 17.02.006.

View Calcs

Displays a list of active Purchase Order User Calculations and their values. 

Import Excel

File explorer used to select the spreadsheet that will be used to add lines to the order. 

Link PO's filter form

Opened via the "Link POs" button on the order header. Used to filter purchase orders that will be linked.

Field/Flag

Description

Continue

Click to link all the filtered POs to this purchase order.

Vendor

Defaults to the Vendor indicated in the Vendor field on the General tab. The POs generated when the Continue is clicked will be filtered by this Vendor.

  • If the "Restrict Link to POs to Same Vendor" field on the Vendor record is checked, this Vendor search box will be disabled.

Order Type

Optional. Defaults to Purchase Order. The POs generated will be filtered to this Order Type. Options are Purchase Order, Quote, Pricing, Complaint, Requisition, and All

Facility

Option to specify a Facility that will be used when filtering POs to link.

  • Defaults to the Facility specified on the purchase order.

Start/End Date

Option to specify the starting and ending purchase order entry dates for filtering.

  • Defaults to empty.

Link PO's form

Displays the Link POs mover form used to move over, then link the appropriate purchase orders. This form is displayed once users click the "Continue" button on the Link PO's filter form.

Filtered POs will be displayed on the left side. User can use the arrow buttons to move the orders to the right hand side of the screen. Once done, the user clicks the "Apply" button to complete the linking process. The linking process is based on the setting in the "Link PO's To" field in Purchasing > Options:

  • If the PO Header option is selected, then all the orders on the right hand side of the mover form will have the "Link To PO" populated with the purchase order number of the PO where the "Link POs" was initially clicked and then will be linked.
  • If the PO Links option is selected, then the "Link To PO" field on the purchase orders on the right hand side of the form will not be populated. The system will link orders from the one being modified to multiple orders, just as in the PO Header option above, but also allow linking to occur in the other direction. meaning multiple purchase orders can be linked back to any purchase order and not just the order being viewed or modified. This is accomplished by storing links in the Linked Orders (dtpurlink) table.

General tab

Field/Flag

Description

PO Number

Displays the sequential, system-generated number.

Vendor

Indicates the Vendor for which this Purchase Order is being created.

  • Once a Vendor is selected, the Order Defaults will populate the appropriate fields on the order being created.
  • Users may be restricted to a specific Vendor, Facility, and/or Facility Group. If restrictions are set, only that record would be available to select.
  • When changing Vendors, the system performs the following checks, and will make changes as follows:
    • Does the new Vendor has a default Facility? If it does, the system will populate this field with the new Facility. If it doesn't have a default Facility, the system will not reset this field, keeping the existing Facility that was in place or leaving the field blank if there was no Facility indicated.
    • Is the order type set to "Purchase Order" or "Transfer and Hold?" If yes, the system will check to see if any of the order lines have parts that require a vendor cross reference part. If none are found, the system will clear any vendor cross reference parts found on the order lines. If parts are found that require a vendor part cross reference, the system will display the following prompt: "This PO has vendor parts assigned which will be cleared if you change the Vendor. Do you want to continue?" If yes is selected, the system will display a list of the parts whose cross references are cleared. If the user tries to save the order, and the Order Type is a Purchase Order or Transfer and Hold order, they will be prompted that the order cannot be saved until the appropriate vendor cross reference parts are selected.

Facility

Indicates the Facility into which the items ordered will be received.

  • Vendor Facility specific defaults which allow users to set Facility specific order defaults by Vendor. If a Facility is selected with a matching Vendor Facility record, the defaults specified on the Vendor Facility record, and not the order defaults on the Vendor record, will be used during order creation. Users may change the defaults if desired.

Freight

Indicates the Freight Type which will be used to determine charges related to shipping the materials.

Ship Via

Indicates the Ship Via Method with which material will be shipped.

  • Facility and order type (sales or purchase order) restrictions can be defined for Ship Via Methods.

Terms

Indicates the Terms that will be used by the company to pay the Vendor for the materials.

  • Example: "2% 10 N 30" implies that the purchaser will receive a 2% discount on the invoice balance if paid within 10 days.

PO Type

Pick list used to determine if this order should be treated as Public or Private.

  • The security setting "Purchase orders -- view private" controls a user’s ability to both create and view Purchase Orders with a "PO Type" of "Private".
  • The option to mark orders as "Private" is useful in situations where certain orders, such as those dealing with monthly rent or equity payments, should only be viewed by accounting personnel.

Order Type

Pick list used to select the type of order being completed. Descriptions for the available options are detailed in Purchase Order Types.

  • Users can be restricted to creating certain Order Types with the exception of the "Complaint" type.

Header Notes

Memo field used to store notes regarding the order.

Order History

Memo field used to display the history of what has occurred on this order, including which users saved, received, invoiced, and applied payment(s).

  • Orders flagged with "Invoice/Pre-Pay" will only show an Invoice Order line, even though the postings will show both receiving and invoicing. This is because the Invoicing and receiving are combined into one step. This applies to orders for either stocked and non-stocked Parts or both.

Currency

Search field used to select the Currency in which the order will be invoiced and paid.

Curr. Conversion

Displays the Currency conversion rate, as defined on the Currency record, if a Currency other than USD is selected.

  • This rate will be updated at the time of receiving so that when viewing the Purchase Order, the system displays the exchange rate from when the PO was received.

Total Order

Displays the total cost of the Purchase Order in the Currency selected.

  • Terms, such as 2% 10 N 30, are not factored into this amount.

Invoice/Pre-Pay 

If checked, when the order is saved, the Enter Invoice Received form will open, which is used to select invoice and date to pay dates, freight and adjustment amounts and accounts, and discounts. At this point the user has two options depending on how the pre-payment is to be processed in the system. These options are:

  • Pre-Pay In Full - Fulfillment Now - The "Pre-Payment" flag will not be checked and the system immediately receives, invoices, and marks the order as paid.
  • Pre-Pay Partial or Full - Fulfillment Later - The "Pre-Payment" flag will be checked and the Purchase Order is saved but is not marked as paid, even though a payment is applied (partial or full). This option allows a pre-paid or credited amount for the customer to be applied against a Purchase Order. When performing the pre-pay with fulfillment later option, the "Received", "System Invoiced", and "Vendor Invoiced" fields will be filled in automatically with the current date but have no effect and are not factored by the system.

Auto Invoice 

If checked, the process of entering a Vendor invoice is skipped and upon receipt, the order is marked as invoiced for the quantity multiplied by the price.

  • This flag will be defaulted based on the "Auto Invoice" flag on the Vendor record.
  • Should only be used in situations when the Vendor's invoice is expected to match the Purchase Order price exactly.
  • Adjustments and Freight may not be added using this option.
  • The "Take Discounts" flag on the Vendor record dictates if discounts will be taken when using the auto invoicing feature.

Misc 1 tab

Field

Description

Ship-To

Indicates the Ship-to Location to which the order will be shipped.

Order Contact

Indicates the Contact for the order.

  • Any Contact that has the Vendor selected on this order set as the "Vendor" on their General tab may be selected.

Text 1-2

Used to enter user-defined details regarding the order.

  • Captions for these fields are managed via System > Maintenance > Captions.
  • These fields are available to the pre-filter on the Purchasing > Receive transaction.

PO Search 1-2

Search fields used to select user-defined data regarding the order.

  • Captions for these fields are managed via System > Maintenance > Captions.
  • The values specified in these fields are available for printing on Purchase Order reports.

Total Weight

Displays the total weight of the order, as defined on the Item Master Calcs tab, once an item is added. 

Job Number

Displays the Job Number, based on the selected Facility, that is associated with this Purchase Order.

  • Useful in situations where a Job is created for capital improvements involving production equipment or production lines. In this case, Purchase Orders are entered for the related maintenance, part replacements, and consulting costs which are then recorded and posted to the linked Job.

Sales Order

Displays the Sales Order Number, based on the selected Facility, that is associated with this Purchase Order.

Progress Billing

Indicates the Progress Billing to which this Purchase Order is linked. 

Link To PO

Displays the Purchase Order to which this Purchase Order is linked.

  • Useful in situations where companies would like to link (1) a credit memo PO or (2) a freight PO to the original PO the item was received on.
  • The "Restrict Link To POs To Same Vendor" flag on the Vendor's Order Defaults tab determines if POs cut to other Vendors may be selected. A PO for a different Vendor may be selected if, for example, the linked PO is for freight charges relating to this order.

Print Substitutions

Searchbox to select any active Print Substitution Groups if applicable to the Purchase Order. This field will automatically populate with the same setting that can be set in Vendors.

Dock

Indicates the Dock where the items on the order will be received, based on the Facility selected.

  • Used in connection with the Dock Calendar.

Project

Option to select form a list of active sales Projects to which the Purchase Order is associated.

Misc 2 tab

Field

Description

AP Account

Determines which Accounts Payable account to credit upon receipt (if not using an AP Suspense account) or invoice (if using an AP Suspense account) of this Purchase Order. 

AP Suspense

Determines which Accounts Payable account to credit upon receipt and debit upon invoice of this Purchase Order. 

Remarks

Memo field used to store internal notes regarding the order.

PO Source

Indicates whether the purchase order was created manually or via MRP.

1099 Form Type

Search field used in conjunction with the "1099 Required" flag to select a 1099 Form Type, which is used to determine which 1099 box the Purchase Order amount should be included on.

  • The selection in this field is used to provide the default setting for the "1099 Form Type" on each individual Purchase Order line.

1099 Required

If checked, indicates that a 1099 Form is required for printing.

  • The "1099 Required" flag on the Vendor's Order Defaults tab determines this flag's default setting.
  • The setting on this field is used as the default setting for the "1099 Required" flag on individual Purchase Order lines.
  • Leaving this flag unchecked is useful in situations where non-reportable reimbursement checks are cut to 1099 Vendors. Note that the system evaluates the 1099 Required flag on individual Purchase Order lines when determining which amounts to include when generating 1099s. Unchecking this flag on the Misc 2 tab will uncheck the same flag on all Purchase Order lines.

Document Group

Option to select a Document Group for this Purchase Order. The default value for this field is provided by the Document Group field on the Vendor record.

  • Added in version 17.04.003.

Broker

Used to select the default Broker for this Vendor when entering new orders. Brokers attached to Purchase Orders will not be returned on Sales Commissions/Rebate reports.

Dates tab

Field

Description

Order Date

Indicates the date the Purchase Order was created.

PO Date 1-5

User-defined dates to indicate items such as Wanted Date, Vendor Confirmation Date, Release Date, etc.

  • Captions for these fields are managed via System > Maintenance > Captions.
  • PO Date 3 (tp_duedock) is set to "Due to Dock (MRP)" by default and is used in conjunction with MRP and the Dock Calendar.
    • In MRP, calculations are based on this date. When creating POs via MRP, Lead Times are considered when defaulting this date.
    • In the Dock Calendar, this date defines when available Dock space is required for receipt of the items on the order.

Expires

Indicates the expiration date of the order.

Pricing Order Based On

Used when Order Type is set to Pricing. Combobox with options of Order Date and PO Date 1-5. Determines the date on which the pricing order will be based on, as opposed to the System Option.

Delivery time

Used in conjunction with the Dock Calendar to indicate the time that the order is planned to arrive at the Dock.

  • Useful when scheduling multiple deliveries to the same receiving Dock.
  • May be printed on purchasing reports and labels.

Work Flow tab

The Work Flow tab displays the Work Flow assigned to the Purchase Order and the associated Sequences that must be completed before the record is considered complete. For more information on the fields and process, refer to the Edit Work Flow Sequence form section of the Work Flow Reporting  page 

  • If selecting a new Vendor on a PO and the Vendor has no Work Flow or the same Work Flow as the current one on the order, the Work Flow will not reset. This is useful in situations where orders are entered without a known source (Vendor), but Work Flow approvals or steps have been completed on the order. In this situation, having the Work Flow not re-fire ensures the necessary approvals are not erased.
  • The header variable "lc_esigby" is available to Purchase Order print outs. This variable will return the name of the user who completed the Work Flow sequence using an E-Signature with the highest minimum PO extension. Example: Assume there are 4 levels for PO Work Flows at 10k, 20k, 30k, and 40k and an order is for 28k. The E-Signature from the 20k level should show, rather than that from the 10k level.

Pricing tab

Field/Flag

Description

Discount

Displays the discount percent that should be applied to the prices entered.

  • If populated prior to adding lines, prices will reflect the Discount entered.
  • If populated after adding lines, the "Recalc Prices" button must be clicked for the Discount entered to take effect.
  • Does not affect manual pricing.

Total Freight Cost

When in actual cost mode, the amount entered in this field is allocated to each Purchase Order line using the following logic:

  • Convert each line item quantity to the selected Ship Via's "Load Unit"* from the Item Master's "Purchase Unit" found on the Units tab.
  • Sum the result of the conversion of all lines to get the total quantity in Load Units.
  • Get the percentage of each line item by dividing the line item amount in the Load Unit quantity by the Total Order Amount in Load Unit quantity.
  • Multiply the "Total Freight Cost" by the result of the above calculation for each line and convert that cost from the Load Unit to the Purchase Unit.
  • Store that value in the "Freight Cost" field of each line.

*If the Ship Via does not have a "Load Unit" specified, the Item Master's "Unit Weight" from the Calcs tab is used.

Available in versions 15.03.017 and above.

Material Burden

When in actual cost mode, the amount entered in this field is allocated to each Purchase Order line and separated from Freight Cost.

Use Qtys For Pricing Orders 

If checked, orders will take quantities into account from Pricing Orders. Otherwise, any quantity will receive the price from the Pricing Order.

Facility-specific pricing orders

If checked, the prices for the items specified on a Pricing Order will only apply to orders created in the same Facility.

  • If not checked, item prices will apply to all Facilities.
  • Only enabled when the "Order Type" is set to a "Pricing Order" option.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. The user fields on a Purchase Order may be used to capture information such as Product Origin, Arrival Time, etc. User fields may be added via Tools > Tools Maintenance > User Fields.

Tax Regions tab

This tab is used to establish regions where purchases from this Vendor are normally taxable and the Tax Regions selected default based on the Vendor selected.

Edit Purchase Order Line form

Opened via the "Add" or "Modify" buttons on the Purchase Order Entry form.

Button

Description

Availability

Generates a Basic Item Availability report which shows the quantities by Part by Facility that are On Hand, Reserved, Pending QC, and pending receipt, finish, or shipment on POs, Jobs, and SOs, respectively.

  • Credit Memos are not taken into consideration in the "-Sales" column.
  • The buttons available to this report are used to drill into the details behind the quantities displayed.

Purchase History

Generates a Purchasing "Purchase Order Detail" report for this item and Vendor, which shows dates and historical prices.

  • Users may drill down into any of this Vendor’s previous Purchase Orders for more details.
  • Beginning in version 17.01.143, the Vendor filter has been removed when running this report. Now, users will see a more comprehensive list of purchase history entries without this restriction. The system will still maintain the limit PO's to those entered by the user restriction, if set.

Part History

Generates an Inventory "History" report for the item on this Purchase Order line.

  • Users may drill down into any of the transactions that have added or removed inventory for this item.

Item Notes

If clicked, displays the Notes for this item from its Item Master General 1 tab.

Pricing Orders

Generates a Purchasing "Purchase Order Detail" report for this item and Vendor with a "View" set to "Pricing".

  • Useful to see minimum order quantity for price breaks in purchasing.

General tab

When adding duplicate lines to Purchase Orders, users will be prompted to confirm, unless the security setting "Purchase orders -- enter duplicate lines without prompt" is set to yes. Note that an item may not be visible if its unit is included on Restricted Purchase Unit on the Item Master.

Field/Flag

Description

Line Number

Displays the system-generated line number.

Part Number

Search field used to select the Part being purchased.

  • When modifying the Facility on a Purchase Order, the system checks to make sure all lines have a Facility item specified, if the part is flagged to "Require Facility Entry" on its Item Master Properties tab.T
  • This field will be disabled when using the "Manufacturing Vendor" field below.

Manufacturing Vendor

Search field used to select the Manufacturer used by the Vendor.

  • Only available when selecting a vendor with the "Require Manufacturing Vendor" field checked. Used in conjunction with the Receiving items requiring Manufacturer Approval feature. When configured:
    • On the PO line, the Part Number Searchbox will be disabled, and the Manufacturing Vendor field will become required and enabled.
    • The Vendor Part Search Box will be disabled until a Manufacturing Vendor is selected. Once a Manufacturing Vendor is selected, the Vendor Part search box will become enabled.
    • The Vendor Part Searchbox will be filtered to only displays records where the Manufacturing Vendor ID matches the corresponding Vendor Part Cross Reference ID.
  • Added in version 16.03.004.

Vendor Part

Search field used to select a Vendor Part Cross Reference, if any exist.

  • If multiple Vendor Parts exist for the same Deacom item number, the system will default to the one flagged as "Preferred" on its General tab.
  • If no Vendor Parts are flagged as "Preferred", the system will default to the first Vendor Part in the list.
  • This field will be display manufacturer approved items only when using the features described in the "Manufacturing Vendor" field above.

UPC Number

Search field used to select a UPC Number, as defined on the Item Master UPC Numbers tab.

Description

Displays the Description of the Part selected.

Charge To

Account to which the Purchase Order will be debited.

Quantity

The amount of the Part being purchased.

  • This value must be a multiple of the "Incremental PO Qty" defined on the Part's Item Master MRP tab, unless the security option to allow non-incremental quantities is set to Yes.

Unit Price

The price for a single unit of the selected Part.

Purchase Unit

The Units in which the Part is purchased.

  • Item Master records contain a restricted purchase unit option on the Units tab which may be used in connection with this field.

Pricing Unit

The Units in which the Part is priced.

  • Defaults to the "Stock Pricing Unit" as defined on the Part's Item Master header.
  • Users with the security setting "Purchase Orders -- change pricing unit" set to yes may change this value.
  • If changed, this will be the unit used for calculating the line's "Extension".

Extension

Displays the extended price of the line, calculated as "Quantity" multiplied by "Quantity Per" multiplied by "Stock Unit Price".

User Part Number

Indicates the user-defined Part number.

Job Number

Displays the Job Number associated with this line used to issue the item to the Job upon receipt.

  • For non-stock or non-inventory items, put the purchased item cost into the "WIP Purchases" account for that Job.
  • If the Job is not a WIP Job or has already been closed:
    • The item is immediately relieved
    • The cost for stocked items is posted to the "Material Expense" account
    • The cost for non-stock or non-inventory items is posted to the "Charge To" account.

Sales Order

Displays the Sales Order Number associated with this line.

  • Useful in keeping track of all steps in the Purchase Order process.

Bill-to Company

Search field used to link the line to a Bill-to Company.

  • Used in situations where companies wish to allocate expenses to their customers.
  • Upon receipt of an order with a "Bill-to Company" selected:
    • The order lines will be displayed in the Sales "Profit Detail" report, when run with a "Status" of "Shipped", with a value of "ap" in the "Order Type" column (A value of "ar" indicates it is a Sales Order line).
    • The Shipped date indicates the Received date of the Purchase Order.
    • Revenue an Profit are represented as a negative extension of the PO line and Cost is 0.

1099 Form Type

Search field used in conjunction with the "1099 Required" flag to select a 1099 Form Type, which is used to determine which 1099 box the Purchase Order line amount should be included on.

  • The values of all Purchase Orders lines with the same 1099 Form Type selected are summed and used to populate the selected box of the 1099 form for the selected time frame when it is printed.

Notes

Memo field used to store notes regarding this line.

Blanket Quantity

Displays the total quantity agreed to purchase from the Vendor. .

Open Blanket

Displays the remaining amount of "Blanket Quantity" available to be purchased.

  • This quantity may be added to Purchasing reports using the "remaining" variable.

Pricing Method

Displays the method by which this line was priced, determined by the "PO Price Type" selection on the Part's Item Master General 1 tab.

  • This field answers the question "Where did that number come from?" regarding the price for the material.

Do Not Post Inventory 

If checked, inventory will not be posted upon receipt of the Purchase Order.

  • This flag, beginning in 17.04.003, is available to be checked, regardless of whether the quantity on the PO lines negative or positive. One scenario where this flexibility is useful is reporting produce quantities, where a certain percentage of the inventory may be non produce material, which may not be readily available or fully calculated until after receipt. The adjustment for this non produce quantity may be negative or positive, and the customer cannot have the adjustment quantity be received as inventory, since the original produce has already been received and processed. Normal invoice transactions will occur for the line.

Linked Sales Orders tab

Sales order lines can be linked to purchase order lines for the purpose of ensuring purchased quantities are automatically reserved to sales orders upon purchase order receipt. See the Reserving to Sales Orders via Purchase Order Allocation page for additional information.

Edit Linked SO form

Opened via the "Add" or "Modified" button. When adding a new linked sales order, users must first select an item in the "Part Number" field on the General tab of the Edit Purchase Order Line form.

Field/Flag

Description

Sales Order

Select the appropriate sales order. Only orders containing lines with an item that matches the item specified on the General tab of the Edit Purchase Order Line form will be displayed in the list.

Note:

If a sales order is not selected, all unshipped lines will be shown.When choosing a sales order, only unshipped or transfer orders are shown.The due to ship date is shown.

Sales Order Line

Indicates the line and item on the sales order that will be reserved as a result of receiving the selected purchase order line. Only sales order lines that match the item selected in the "Part Number" field of the purchase order line and have "Linked PO Allocatable" checked will be displayed in the search box.The due to ship date is shown.

Quantity

The quantity that will be reserved when the purchase order is received. The value in this field cannot be greater than the value in the Remaining Quantity field below.

Sales Unit

Displays the sales unit of measure for the item on the sales order line that is selected above.

Remaining Quantity

Displays the quantity left to allocate, in the purchase unit of measure, for the selected order line.

Note: Once a sales order line has been added to the Linked Sales Order tab the system will convert the quantity that is displayed in the grid from the sales unit of measure to the purchase unit of measure. For example, if the sales unit of measure is pounds and the purchase unit of measure is ton, and a quantity of 50 is entered on the Edit Linked SO form above and saved, the system will display a quantity of .025 in the quantity column on the grid in the Linked Sales Orders tab.

Dates tab

Field/Flag

Description

PO Date 1-5

Specifies user-defined dates if different than those on the Purchase Order header.

  • PO Date 3 (pu_duedock) represents the "Due to Dock" date and is used in conjunction with MRP and the Dock Calendar. The value in this field defaults from the value specified in the "Due to Dock (MRP)" (tp_duedock) date field on the Purchase Order header but may be changed.
    • In MRP, calculations are based on this date, if present, otherwise MRP will use the tp_duedock date. When creating POs via MRP, Lead Times are considered when defaulting this date.
    • In the Dock Calendar, this date, if present, defines when available Dock space is required for receipt of the items on the order, otherwise the tp_duedock date on the Purchase Order header will be used.

Expires

Indicates the expiration date of the purchase order line. Default from the "Expires" field on the Purchase Order header but may be changed.

Dock Minutes

Indicates the time it takes to unload or receive a "Purchase Unit" of the Part selected at a Dock.

  • The default value for this field is based on the Unit of Measure Receipt Minutes hierarchy, detailed in Scheduling Warehouse Docks, when a quantity greater then 1 is indicated.
  • The total minutes will be based on the calculation of the pu_quant x un_recmins.

Pricing tab

Field/Flag

Description

Discount

Indicates the discount, in percent form, that applies to this line.

  • Does not affect manual pricing

Standard Cost

Displays the standard cost of the Part as defined by the "Acct. Std. Total" field on the Item Master Costs tab. 

Freight Cost

The current freight amount, in dollars per a Pricing Unit of the item.

  • When costs are added to this field, they will not update the extensions (line total and order total) on the order lines or the order header. This is by design as the values in this field are used for linking freight cost to inventory cost. Instead, when in actual cost mode, if the value in this field is modified, each line's "Freight Cost" is converted from "Purchase Unit" to "Load Unit" then summed and the sum is stored in the Purchase Order header's "Total Freight Cost" field on the Pricing tab.
  • The value is field is added to the cost per unit and recorded under the Inventory GL posting upon receiving.
  • The "Freight In" account in Accounting Options is the offsetting account when items are received to ensure the AP/Freight In inventory accounts balance. This is designed so that if this field is used, a separate invoice is expected from the trucking company or the Vendor for the freight amount owed.
  • If the Vendor is charging for freight on the same PO as the materials, a User Calculation can be set up to add all the freight costs on the order and add a line to the order to offset the "Freight In" account accordingly.

Material Burden

The material burden amount for the purchase order line.

  • This field, material burden was accounted by adding the value to the value specified in the "Freight Cost" field.
  • Only available when using actual (FIFO) or average cost mode. When in standard cost mode, this field is disabled. Separated from Freight Cost .
  • Note: When adding a line to a Purchase Order, if a Vendor Part Cross Reference is selected for the item specified on the order line, the default value for this field will be based on the value in the "Material Burden" field on the Edit Vendor Price form if that value is greater than 0.

Stock Pricing Unit

Displays the Units in which the Part is priced, as defined on the Part's Item Master header. 

Stock Pricing Factor

Displays the stock pricing factor for the Part, defined as the number of stock pricing units per stock unit.

Stock Unit Price

Displays the price per Stock Unit of the Part.

Stock Unit

Displays the Units in which the Part is stocked, as defined on the Part's Item Master header. 

Quantity Per

Displays the quantity per "Purchase Unit" of the item, represented by the Factor on the Unit. 

Quantity Ordered

Displays the number of units ordered.

Total Order Pricing

If checked, allows a Pricing Order line to consider the entire quantity in terms of the Purchase Unit when checking for the minimum quantity.

  • Only applicable for Purchase Orders with an "Order Type" of "Pricing".
  • If the Purchasing Unit of the pricing line is "lbs" then the quantities of all of the order lines are converted to "lbs" and summed.
  • If the total is greater than or equal to the quantity on the pricing line, then its price is used.
  • When a Pricing Order has a line item flagged with "Total Order Pricing" and the quantity is in a weight unit, the unit and tare weights of the items on the order are summed.

1099 Required

If checked, indicates that a 1099 Form is required for printing.

  • Leaving this flag unchecked is useful in situations where non-reportable reimbursement checks are cut to 1099 Vendors.
  • The "1099 Required" flag on the Misc 2 tab of the Purchase Order provides the default setting for this field.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. User fields may be added via Tools > Tools Maintenance > User Fields.

(Widgets) tab

Available beginning in version 17.04.008

The widgets tab feature is available to enhance the visibility of key business metrics within the Sales Order, Purchase Order, and Job line items. This feature, known as the "hero tile," displays a series of informative sub-tiles or "badges" when a part is selected. These badges provide valuable insights through various data points such as open orders, on-hand quantities, and sales performance metrics. Users have the flexibility to view this information in numerical form, as graphs, or both. The development involved significant updates to the platform's front-end and back-end code, including the implementation of consistent styling for these badges and the creation of logic to manage the hero tile. The system now supports widgets that can pull detailed information based on specific parameters, enhancing user interaction and data accessibility. See Item Information Widgets for setup details.